using HKB.Common;
using System;
using System.Data;
using System.Web;
public class ChinaCity
{
	private Conn conn = null;
	public ChinaCity(Conn _conn)
	{
		this.conn = _conn;
	}
	public ChinaCity()
	{
		this.conn = Text.GetComponent<Conn>("conn", HttpContext.Current.CurrentHandler);
	}
	public DataTable GetProvince()
	{
		return this.conn.GetDataTable("Select DISTINCT(Province) From [HL_City]");
	}
	public DataTable GetCityByProvince(string Province)
	{
		IDbDataParameter dbDataParameter = this.conn.CreateParameter("@Province", DbType.String, Province);
		return this.conn.GetDataTable("SELECT DISTINCT(City) From [HL_City] Where ([Province] = @Province)", new IDbDataParameter[]
		{
			dbDataParameter
		});
	}
	public DataTable GetAreaByCity(string City)
	{
		IDbDataParameter dbDataParameter = this.conn.CreateParameter("@City", DbType.String, City);
		return this.conn.GetDataTable("SELECT DISTINCT(Area) From [HL_City] Where ([City] = @City)", new IDbDataParameter[]
		{
			dbDataParameter
		});
	}
}
